package com.example.demo.Mappers;

import com.example.demo.beans.GetMZFYItem;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018-05-22.
 */
@Mapper
public interface GetMZFYListMapper {
@Select("select ExecDept,OperDateTime,ItemName,ItemType,Specs,Unit,Price,Num,Cost from Auto_View_GetMZFYList where CardNo =#{CardNo} and OperDateTime>=#{StartDate}  and OperDateTime<=#{EndDate}  ")
    List<GetMZFYItem> getMzfyItem(@Param("CardNo")String CardNo,@Param("StartDate")String StartDate,@Param("EndDate")String EndDate);
}
